Dec 12 2021 05:44 AM
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
Dec 12 2021 05:50 AM - edited Dec 12 2021 05:51 AM
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
Dec 12 2021 07:06 AM
@Juliano-Petrukio
Hi,
As per the OP request - Instead of "Format it..." I would suggest "Format Both...".
Micky Avidan