Need Help with dates

Copper Contributor

Hi,

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. 

Thanks

2 Replies

Lets say your date is on A2
On B2 the formula
=A2+3

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

 

 

@Juliano-Petrukio 
Hi,
As per the OP request - Instead of "Format it..." I would suggest "Format Both...".
Micky Avidan