Previous Topic Next Topic

Help( excel)

Closed
MAndo - Jan 3, 2011 at 02:16 PM
 Armando - Jan 5, 2011 at 10:00 AM
Hello, My name is Mando

how to tell excel cell A1=B1 and say if we get A1 then its this???

A is a number that we have registered as a working date and B1 is a Date but if i say the working date is 703 it will automatically display the date in this case is 1/3/2012?????

please help



Related:

1 response

Answer 1 / 1
Armando
Jan 5, 2011 at 10:00 AM
LEt me explain what im doing that way it can make sence, I am creating a calendar in excel that has a certain amount of working days so i just was to type in a working day and display its working date ex: working day 703 corresponds to 1/3/2012 so A1= 703; B1= 1/3/2012

how do i tell excel that A1=B1 so If B1 is shown in cell D85 then display A1 in the cell right next to it which is E85????
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses