I need to input the date in one cell and have the adjacent cell show the date 45 days on . How can I do that ?

Format the cells as dates.
Enter the date in the first cell
In the second cell put =+A1+45 (where A1 is the cell with the date – adjust for your cell(s))

=a1+45

that simple.

the date code has units of 1 day.

cheers lads thats got me fixed !

ok moving forward from that how do i make the first cell always read the current day ?

leave cell formatted as date and put this in =NOW()

cheers again , what would I do without STW…

read the manual / help? 😉

tried the help button but its all computor talk to me…lol

=TODAY()

gives you just the date, whereas now gives you the date and time.
Not that important a distinction but cleaner.