Need Help with dates

Occasional Visitor


I want to enter in a cell a random date that will also show day of the week. Next I want to create a formula that the cell I enter the formula in will show the date I entered in the 1st cell  +3 days, again showing date and day of the week. 


2 Replies

Lets say your date is on A2
On B2 the formula

Then to format it, CTRL+1 and then format it as custom to:
ddd dd/mm/yyyy



As per the OP request - Instead of "Format it..." I would suggest "Format Both...".
Micky Avidan