Excel 2007 pulling part of a date from one sheet to another??? Help

[sibley14]

Hi,

Is there a formula that will pull the DD or MM from a date format of DD/MM/YYY only?

I have two excel sheets and i want to link the date from sheet 1 to sheet 2.

On sheet 1 the date is in this format DD/MM/YYYY and this is in 1 full cell as we add the date quickly using Ctrl+:

Sheet 2 needs to pull the DD and MM only from sheet 1. These are located in seperate cells so i guess each will have it's own formula.

So i trying to achieve a formula that will read the DD and MM only from sheet 1 to sheet 2

 

[Jonmo1]

Welcome to the board.

Try the DAY and MONTH functions

=DAY(A1)
=MONTH(A1)

 

[sibley14]

Thanks Jonmo1,

i can't seem to get it working. I've tried those formulas on each day/month cell on sheet 2 hoping that it will pull the day/month from sheet 1 which has the date as DD/MM/YYYY format. However i'm just getting an error and have checked the calculation steps to see if it will identify the fault. Currently it doesnt seem to be working - although i'll persevere!

Oh and by the way the 2 sheets are seperate from each other. They are not on the same worksheet and are located in different locations on the server.

Thanks for responding so quickly.

 

[Jonmo1]

Can you post the actual formula(s) you tried?

You said you enter the dates by just pressing Ctrl+:
So those should be valid dates, and the Day / Month functions will work on that cell.

You probably need to include a sheet reference
=DAY('Sheet 1'!A1)